﻿<%@ Page Title="" Language="vb" AutoEventWireup="false" MasterPageFile="~/Site.Master" CodeBehind="detail.aspx.vb" Inherits="cricketmania.detail" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">
    <p>
    <br />
</p>
<p>
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
        DataKeyNames="ID" DataSourceID="cmSqlDataSource1">
        <Columns>
            <asp:BoundField 
                SortExpression="schedule" />
            <asp:BoundField DataField="Results" HeaderText="Results" 
                SortExpression="Results" />
            <asp:BoundField DataField="Ratings" HeaderText="Ratings" 
                SortExpression="Ratings" />
            <asp:BoundField DataField="RelatedWebsites" HeaderText="RelatedWebsites" 
                SortExpression="RelatedWebsites" />
            <asp:ImageField DataImageUrlField="Gallery" HeaderText="Thumbnail">
            </asp:ImageField>
        </Columns>
    </asp:GridView>
    <asp:SqlDataSource ID="cmSqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:maniaConnectionString %>" 
        ProviderName="<%$ ConnectionStrings:maniaConnectionString.ProviderName %>" 
        
        SelectCommand="SELECT [schedule], [Results], [Ratings], [RelatedWebsites], [Gallery], [ID] FROM [crick] WHERE ([ID] = ?)">
        <SelectParameters>
            <asp:QueryStringParameter Name="ID" QueryStringField="ID" Type="Int32" />
        </SelectParameters>
    </asp:SqlDataSource>
</p>
    <p>
        <asp:GridView ID="GridView3" runat="server" AutoGenerateColumns="False" 
            DataKeyNames="ID" DataSourceID="SqlDataSource3">
            <Columns>
                <asp:BoundField DataField="Results" HeaderText="Results" 
                    SortExpression="Results" />
                <asp:BoundField DataField="schedule" HeaderText="schedule" 
                    SortExpression="schedule" />
                <asp:HyperLinkField DataNavigateUrlFields="ID" 
                    DataNavigateUrlFormatString="rating.aspx?ID={0}" HeaderText="Rate" 
                    Text="Rate" />
            </Columns>
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource3" runat="server" 
            ConnectionString="<%$ ConnectionStrings:maniaConnectionString %>" 
            ProviderName="<%$ ConnectionStrings:maniaConnectionString.ProviderName %>" 
            SelectCommand="SELECT [Results], [ID], [schedule] FROM [crick] WHERE ([ID] = ?)">
            <SelectParameters>
                <asp:QueryStringParameter Name="ID" QueryStringField="ID" Type="Int32" />
            </SelectParameters>
        </asp:SqlDataSource>
</p>
    <p>
        <asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" 
            DataSourceID="SqlDataSource1">
            <Columns>
                <asp:BoundField DataField="Author" HeaderText="Author" 
                    SortExpression="Author" />
                <asp:BoundField DataField="Title" HeaderText="Title" SortExpression="Title" />
                <asp:BoundField DataField="comment" HeaderText="comment" 
                    SortExpression="comment" />
                <asp:BoundField DataField="cricfkid" HeaderText="cricfkid" 
                    SortExpression="cricfkid" />
            </Columns>
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            ConnectionString="<%$ ConnectionStrings:maniaConnectionString %>" 
            ProviderName="<%$ ConnectionStrings:maniaConnectionString.ProviderName %>" 
            SelectCommand="SELECT [Author], [Title], [comment], [cricfkid] FROM [comment] WHERE ([cricfkid] = ?)">
            <SelectParameters>
                <asp:QueryStringParameter Name="cricfkid" QueryStringField="ID" Type="Int32" />
            </SelectParameters>
        </asp:SqlDataSource>
</p>
    <p>
        &nbsp;</p>
    <p>
        Title&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
        <asp:TextBox ID="T1" runat="server"></asp:TextBox>
</p>
    <p>
        Comment</p>
    <p>
    &nbsp;&nbsp;&nbsp;&nbsp;
        <asp:TextBox ID="T2" runat="server" Height="231px" TextMode="MultiLine" 
            Width="440px"></asp:TextBox>
</p>
<p>
    <asp:Button ID="Button1" runat="server" Text="Add Comment" Width="125px" />
</p>
<p>
    <asp:CheckBoxList ID="Cbl" runat="server" DataSourceID="SqlDataSource2" 
        DataTextField="TagName" DataValueField="ID" RepeatDirection="Horizontal">
    </asp:CheckBoxList>
    <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
        ConnectionString="<%$ ConnectionStrings:maniaConnectionString %>" 
        ProviderName="<%$ ConnectionStrings:maniaConnectionString.ProviderName %>" 
        SelectCommand="SELECT [ID], [TagName] FROM [Tags]"></asp:SqlDataSource>
</p>
<p>
    <asp:Button ID="Button2" runat="server" Text="Tag View" />
</p>
    <p>
        <asp:TextBox ID="At" runat="server" Width="195px"></asp:TextBox>
        <asp:Button ID="Button3" runat="server" Text="Add Tag" Width="90px" />
</p>
<p>
</p>
</asp:Content>
